Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	16247
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	104.0 B

Variable types

Categorical	1
Numeric	12

Warnings

`gene` has a high cardinality: 16247 distinct values	High cardinality
`C42_1` is highly correlated with `C42_2` and 10 other fields	High correlation
`C42_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_1` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_2` is highly correlated with `C42_1` and 5 other fields	High correlation
`C42B_3` is highly correlated with `C42_1` and 10 other fields	High correlation
`LNCAP_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`LNCAP_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`LNCAP_3` is highly correlated with `C42_1` and 10 other fields	High correlation
`MR49F_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`MR49F_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`MR49F_3` is highly correlated with `C42_1` and 10 other fields	High correlation
`C42_1` is highly correlated with `C42_2` and 10 other fields	High correlation
`C42_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_1` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_2` is highly correlated with `C42_1` and 5 other fields	High correlation
`C42B_3` is highly correlated with `C42_1` and 10 other fields	High correlation
`LNCAP_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`LNCAP_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`LNCAP_3` is highly correlated with `C42_1` and 10 other fields	High correlation
`MR49F_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`MR49F_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`MR49F_3` is highly correlated with `C42_1` and 10 other fields	High correlation
`C42_1` is highly correlated with `C42_2` and 8 other fields	High correlation
`C42_2` is highly correlated with `C42_1` and 1 other fields	High correlation
`C42_3` is highly correlated with `C42_1` and 3 other fields	High correlation
`C42B_1` is highly correlated with `C42_1` and 3 other fields	High correlation
`C42B_3` is highly correlated with `C42_1` and 5 other fields	High correlation
`LNCAP_1` is highly correlated with `C42_1` and 4 other fields	High correlation
`LNCAP_2` is highly correlated with `C42_1` and 7 other fields	High correlation
`MR49F_1` is highly correlated with `C42_1` and 6 other fields	High correlation
`MR49F_2` is highly correlated with `C42_1` and 5 other fields	High correlation
`MR49F_3` is highly correlated with `C42_1` and 4 other fields	High correlation
`C42B_2` is highly correlated with `C42B_1` and 10 other fields	High correlation
`C42B_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`MR49F_3` is highly correlated with `C42B_2` and 10 other fields	High correlation
`C42_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`MR49F_2` is highly correlated with `C42B_2` and 10 other fields	High correlation
`LNCAP_2` is highly correlated with `C42B_2` and 10 other fields	High correlation
`LNCAP_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`LNCAP_3` is highly correlated with `C42B_2` and 10 other fields	High correlation
`C42B_3` is highly correlated with `C42B_2` and 10 other fields	High correlation
`C42_3` is highly correlated with `C42B_2` and 10 other fields	High correlation
`MR49F_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`C42_2` is highly correlated with `C42B_2` and 10 other fields	High correlation
`gene` is uniformly distributed	Uniform
`gene` has unique values	Unique
`C42_2` has 211 (1.3%) zeros	Zeros
`C42_3` has 234 (1.4%) zeros	Zeros
`C42B_1` has 187 (1.2%) zeros	Zeros
`C42B_2` has 195 (1.2%) zeros	Zeros
`C42B_3` has 181 (1.1%) zeros	Zeros
`LNCAP_1` has 318 (2.0%) zeros	Zeros
`LNCAP_2` has 349 (2.1%) zeros	Zeros
`LNCAP_3` has 369 (2.3%) zeros	Zeros
`MR49F_1` has 347 (2.1%) zeros	Zeros
`MR49F_2` has 391 (2.4%) zeros	Zeros
`MR49F_3` has 406 (2.5%) zeros	Zeros

Reproduction

Analysis started	2021-09-03 02:25:04.080821
Analysis finished	2021-09-03 02:25:49.425536
Duration	45.34 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

gene
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	16247
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	127.1 KiB

ENSG00000000003	1
ENSG00000183617	1
ENSG00000183506	1
ENSG00000183508	1
ENSG00000183513	1
Other values (16242)	16242

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	243705
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16247 ?
Unique (%)	100.0%

Sample

1st row	ENSG00000000003
2nd row	ENSG00000000419
3rd row	ENSG00000000457
4th row	ENSG00000000460
5th row	ENSG00000001036

Common Values

Value	Count	Frequency (%)
ENSG00000000003	1	< 0.1%
ENSG00000183617	1	< 0.1%
ENSG00000183506	1	< 0.1%
ENSG00000183508	1	< 0.1%
ENSG00000183513	1	< 0.1%
ENSG00000183520	1	< 0.1%
ENSG00000183527	1	< 0.1%
ENSG00000183530	1	< 0.1%
ENSG00000183570	1	< 0.1%
ENSG00000183576	1	< 0.1%
Other values (16237)	16237	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ensg00000000003	1	< 0.1%
ensg00000183617	1	< 0.1%
ensg00000183506	1	< 0.1%
ensg00000183508	1	< 0.1%
ensg00000183513	1	< 0.1%
ensg00000183520	1	< 0.1%
ensg00000183527	1	< 0.1%
ensg00000183530	1	< 0.1%
ensg00000183570	1	< 0.1%
ensg00000183576	1	< 0.1%
Other values (16237)	16237	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	91209	37.4%
1	18255	7.5%
E	16247	6.7%
N	16247	6.7%
S	16247	6.7%
G	16247	6.7%
2	11778	4.8%
6	8946	3.7%
3	8563	3.5%
7	8546	3.5%
Other values (4)	31420	12.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	178717	73.3%
Uppercase Letter	64988	26.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	91209	51.0%
1	18255	10.2%
2	11778	6.6%
6	8946	5.0%
3	8563	4.8%
7	8546	4.8%
4	8236	4.6%
5	8044	4.5%
8	8020	4.5%
9	7120	4.0%

Uppercase Letter

Value	Count	Frequency (%)
E	16247	25.0%
N	16247	25.0%
S	16247	25.0%
G	16247	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	178717	73.3%
Latin	64988	26.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	91209	51.0%
1	18255	10.2%
2	11778	6.6%
6	8946	5.0%
3	8563	4.8%
7	8546	4.8%
4	8236	4.6%
5	8044	4.5%
8	8020	4.5%
9	7120	4.0%

Latin

Value	Count	Frequency (%)
E	16247	25.0%
N	16247	25.0%
S	16247	25.0%
G	16247	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	243705	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	91209	37.4%
1	18255	7.5%
E	16247	6.7%
N	16247	6.7%
S	16247	6.7%
G	16247	6.7%
2	11778	4.8%
6	8946	3.7%
3	8563	3.5%
7	8546	3.5%
Other values (4)	31420	12.9%

C42_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	16097
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.873633301

Minimum	0
Maximum	9.82417682
Zeros	82
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1193089608
Q1	0.6984957421
median	1.75935523
Q3	2.810570692
95-th percentile	4.185666553
Maximum	9.82417682
Range	9.82417682
Interquartile range (IQR)	2.112074949

Descriptive statistics

Standard deviation	1.319332383
Coefficient of variation (CV)	0.7041572021
Kurtosis	-0.192118322
Mean	1.873633301
Median Absolute Deviation (MAD)	1.057375917
Skewness	0.5500007249
Sum	30440.92024
Variance	1.740637937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	82	0.5%
1.73799221	4	< 0.1%
3.69011116	3	< 0.1%
0.1092280087	3	< 0.1%
1.925327601	3	< 0.1%
0.2178690246	2	< 0.1%
0.007839389435	2	< 0.1%
2.698841329	2	< 0.1%
1.773304552	2	< 0.1%
2.513325643	2	< 0.1%
Other values (16087)	16142	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	82	0.5%
0.001364349381	1	< 0.1%
0.001853355043	1	< 0.1%
0.001883753284	1	< 0.1%
0.001956915123	1	< 0.1%
0.002094037444	1	< 0.1%
0.002147392596	1	< 0.1%
0.002175304875	1	< 0.1%
0.002191377996	1	< 0.1%
0.002369805402	1	< 0.1%

Value	Count	Frequency (%)
9.82417682	1	< 0.1%
8.109056387	1	< 0.1%
7.821795507	1	< 0.1%
7.644937017	1	< 0.1%
7.400060092	1	< 0.1%
7.358750679	1	< 0.1%
7.09071949	1	< 0.1%
7.029278638	1	< 0.1%
6.824848557	1	< 0.1%
6.779525388	1	< 0.1%

C42_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14899
Distinct (%)	91.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.470975692

Minimum	0
Maximum	10.47408629
Zeros	211
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.399655399
Q1	1.812863228
median	3.324787279
Q3	5.001315209
95-th percentile	6.929211369
Maximum	10.47408629
Range	10.47408629
Interquartile range (IQR)	3.188451981

Descriptive statistics

Standard deviation	2.029188935
Coefficient of variation (CV)	0.5846162911
Kurtosis	-0.785638385
Mean	3.470975692
Median Absolute Deviation (MAD)	1.590965869
Skewness	0.2547675167
Sum	56392.94206
Variance	4.117607735
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	211	1.3%
4.84681738	11	0.1%
3.09357324	7	< 0.1%
1.425121289	7	< 0.1%
3.763789682	7	< 0.1%
2.710524818	7	< 0.1%
2.389550297	7	< 0.1%
2.407553838	7	< 0.1%
2.22623015	7	< 0.1%
5.758384976	6	< 0.1%
Other values (14889)	15970	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	211	1.3%
0.01085436137	1	< 0.1%
0.01227974541	1	< 0.1%
0.01577406273	1	< 0.1%
0.0168356417	1	< 0.1%
0.01853642495	1	< 0.1%
0.01868308742	1	< 0.1%
0.01924960668	1	< 0.1%
0.02433763292	1	< 0.1%
0.02514668365	1	< 0.1%

Value	Count	Frequency (%)
10.47408629	1	< 0.1%
9.776450956	1	< 0.1%
9.73424549	1	< 0.1%
9.70980336	1	< 0.1%
9.524491242	1	< 0.1%
9.504956259	1	< 0.1%
9.439460088	1	< 0.1%
9.37393966	1	< 0.1%
9.341501756	1	< 0.1%
9.313147464	1	< 0.1%

C42_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14884
Distinct (%)	91.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.465547674

Minimum	0
Maximum	10.70029066
Zeros	234
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.423906818
Q1	2.031656036
median	3.542020826
Q3	4.823072382
95-th percentile	6.412240688
Maximum	10.70029066
Range	10.70029066
Interquartile range (IQR)	2.791416346

Descriptive statistics

Standard deviation	1.83756014
Coefficient of variation (CV)	0.530236578
Kurtosis	-0.6690717012
Mean	3.465547674
Median Absolute Deviation (MAD)	1.384923715
Skewness	0.04434617256
Sum	56304.75306
Variance	3.376627267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	234	1.4%
4.951359849	13	0.1%
3.194358183	10	0.1%
4.26526155	9	0.1%
2.337740317	8	< 0.1%
2.710494353	8	< 0.1%
3.866795984	8	< 0.1%
5.640963868	8	< 0.1%
1.764772548	8	< 0.1%
1.468351912	7	< 0.1%
Other values (14874)	15934	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	234	1.4%
0.007214924484	1	< 0.1%
0.01829132494	1	< 0.1%
0.02240524036	1	< 0.1%
0.02529871395	1	< 0.1%
0.02797351339	1	< 0.1%
0.02839225109	1	< 0.1%
0.02925629709	1	< 0.1%
0.03127387137	1	< 0.1%
0.03417931891	1	< 0.1%

Value	Count	Frequency (%)
10.70029066	1	< 0.1%
10.28870041	1	< 0.1%
9.756287348	1	< 0.1%
9.368592548	1	< 0.1%
9.282111492	1	< 0.1%
9.055251575	1	< 0.1%
9.034628277	1	< 0.1%
9.02425502	1	< 0.1%
8.959645688	1	< 0.1%
8.914885814	1	< 0.1%

C42B_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	15613
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.918773055

Minimum	0
Maximum	10.32358267
Zeros	187
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1447911429
Q1	1.009657556
median	2.788548116
Q3	4.512616774
95-th percentile	6.450719129
Maximum	10.32358267
Range	10.32358267
Interquartile range (IQR)	3.502959218

Descriptive statistics

Standard deviation	2.062234389
Coefficient of variation (CV)	0.7065415331
Kurtosis	-0.8495525939
Mean	2.918773055
Median Absolute Deviation (MAD)	1.754316903
Skewness	0.3446148066
Sum	47421.30583
Variance	4.252810676
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	187	1.2%
3.675321952	9	0.1%
4.072304099	8	< 0.1%
3.181249373	7	< 0.1%
2.626149608	5	< 0.1%
2.528796561	5	< 0.1%
3.007200251	5	< 0.1%
1.415486253	5	< 0.1%
5.849763402	5	< 0.1%
3.790285322	5	< 0.1%
Other values (15603)	16006	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	187	1.2%
0.005993780567	1	< 0.1%
0.008204440578	1	< 0.1%
0.008842635714	1	< 0.1%
0.00989351508	1	< 0.1%
0.01035662157	1	< 0.1%
0.01079810265	1	< 0.1%
0.01263434842	1	< 0.1%
0.01277846996	1	< 0.1%
0.01315433119	1	< 0.1%

Value	Count	Frequency (%)
10.32358267	1	< 0.1%
9.45638983	1	< 0.1%
9.365799434	1	< 0.1%
9.283742651	1	< 0.1%
9.088617438	1	< 0.1%
9.074148443	1	< 0.1%
9.013550427	1	< 0.1%
9.011371121	1	< 0.1%
8.916786898	1	< 0.1%
8.869549747	1	< 0.1%

C42B_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14931
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.563954325

Minimum	0
Maximum	11.40843506
Zeros	195
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2283601025
Q1	1.388233287
median	2.466024948
Q3	3.494395979
95-th percentile	5.472677812
Maximum	11.40843506
Range	11.40843506
Interquartile range (IQR)	2.106162692

Descriptive statistics

Standard deviation	1.587348481
Coefficient of variation (CV)	0.6191017
Kurtosis	0.5509968324
Mean	2.563954325
Median Absolute Deviation (MAD)	1.051976127
Skewness	0.6497734073
Sum	41656.56592
Variance	2.519675201
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	195	1.2%
2.885149577	20	0.1%
1.951316212	17	0.1%
2.473871051	14	0.1%
1.228229605	14	0.1%
3.115084604	14	0.1%
2.659103541	13	0.1%
1.76307805	13	0.1%
2.366565195	12	0.1%
2.570770063	12	0.1%
Other values (14921)	15923	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	195	1.2%
0.007541033241	1	< 0.1%
0.007579962824	1	< 0.1%
0.009194944442	1	< 0.1%
0.01137081075	1	< 0.1%
0.01283588482	1	< 0.1%
0.01296988281	1	< 0.1%
0.01301954417	1	< 0.1%
0.0134589391	1	< 0.1%
0.01416572715	1	< 0.1%

Value	Count	Frequency (%)
11.40843506	1	< 0.1%
11.3243066	1	< 0.1%
10.98841191	1	< 0.1%
10.92950329	1	< 0.1%
10.65332295	1	< 0.1%
10.13192888	1	< 0.1%
9.984720385	1	< 0.1%
9.659343106	1	< 0.1%
9.580673384	1	< 0.1%
9.363200268	1	< 0.1%

C42B_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	15151
Distinct (%)	93.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.343280361

Minimum	0
Maximum	10.71824787
Zeros	181
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.4542662817
Q1	1.885719111
median	3.406084391
Q3	4.672537658
95-th percentile	6.301911618
Maximum	10.71824787
Range	10.71824787
Interquartile range (IQR)	2.786818548

Descriptive statistics

Standard deviation	1.806866958
Coefficient of variation (CV)	0.5404473339
Kurtosis	-0.6346609609
Mean	3.343280361
Median Absolute Deviation (MAD)	1.380147917
Skewness	0.1166613342
Sum	54318.27603
Variance	3.264768203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	181	1.1%
3.368189632	10	0.1%
2.080251583	10	0.1%
4.728305339	8	< 0.1%
3.153622188	8	< 0.1%
1.393724308	7	< 0.1%
1.504797466	7	< 0.1%
1.887855154	6	< 0.1%
2.708914222	6	< 0.1%
2.903985737	6	< 0.1%
Other values (15141)	15998	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	181	1.1%
0.0123872396	1	< 0.1%
0.01466382938	1	< 0.1%
0.02020300821	1	< 0.1%
0.02517026053	1	< 0.1%
0.02796011607	1	< 0.1%
0.02870933115	1	< 0.1%
0.02940983267	1	< 0.1%
0.03656696742	1	< 0.1%
0.03665785364	1	< 0.1%

Value	Count	Frequency (%)
10.71824787	1	< 0.1%
10.47298837	1	< 0.1%
10.21197161	1	< 0.1%
10.09850305	1	< 0.1%
9.803210704	1	< 0.1%
9.550019465	1	< 0.1%
9.470522886	1	< 0.1%
9.36169434	1	< 0.1%
9.357248435	1	< 0.1%
9.339253423	1	< 0.1%

LNCAP_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14848
Distinct (%)	91.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.52366053

Minimum	0
Maximum	10.01901215
Zeros	318
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3398317244
Q1	2.015348444
median	3.600576441
Q3	4.926999833
95-th percentile	6.68293842
Maximum	10.01901215
Range	10.01901215
Interquartile range (IQR)	2.911651389

Descriptive statistics

Standard deviation	1.930274248
Coefficient of variation (CV)	0.547803692
Kurtosis	-0.6766104237
Mean	3.52366053
Median Absolute Deviation (MAD)	1.444887145
Skewness	0.07047483539
Sum	57248.91263
Variance	3.725958672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	318	2.0%
3.3625783	12	0.1%
3.64156119	11	0.1%
2.828615017	11	0.1%
2.02235795	9	0.1%
2.703490281	8	< 0.1%
2.258987256	8	< 0.1%
4.72254474	8	< 0.1%
3.49176956	8	< 0.1%
1.730578677	8	< 0.1%
Other values (14838)	15846	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	318	2.0%
0.008335724779	1	< 0.1%
0.01029823999	1	< 0.1%
0.01493504004	1	< 0.1%
0.01688551926	1	< 0.1%
0.01925423291	1	< 0.1%
0.01945930238	1	< 0.1%
0.0214271758	1	< 0.1%
0.02321712129	1	< 0.1%
0.02433759826	1	< 0.1%

Value	Count	Frequency (%)
10.01901215	1	< 0.1%
9.913138735	1	< 0.1%
9.686614771	1	< 0.1%
9.659438632	1	< 0.1%
9.588566655	1	< 0.1%
9.509056855	1	< 0.1%
9.407079132	1	< 0.1%
9.389783154	1	< 0.1%
9.28361842	1	< 0.1%
9.275997183	1	< 0.1%

LNCAP_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	15647
Distinct (%)	96.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.203438231

Minimum	0
Maximum	10.13682209
Zeros	349
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.07631100492
Q1	0.6781101745
median	1.956277779
Q3	3.296716518
95-th percentile	5.506760363
Maximum	10.13682209
Range	10.13682209
Interquartile range (IQR)	2.618606344

Descriptive statistics

Standard deviation	1.751905064
Coefficient of variation (CV)	0.7950779101
Kurtosis	0.237234816
Mean	2.203438231
Median Absolute Deviation (MAD)	1.303572909
Skewness	0.8125895476
Sum	35799.26094
Variance	3.069171353
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	349	2.1%
1.589064585	4	< 0.1%
0.415618733	4	< 0.1%
2.235948532	4	< 0.1%
0.3339871196	3	< 0.1%
0.738705251	3	< 0.1%
0.886459544	3	< 0.1%
2.809201237	3	< 0.1%
0.9649481937	3	< 0.1%
0.9869700052	3	< 0.1%
Other values (15637)	15868	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	349	2.1%
0.006433052218	1	< 0.1%
0.007317144753	1	< 0.1%
0.00740421864	1	< 0.1%
0.007895489697	1	< 0.1%
0.008374249886	1	< 0.1%
0.008915499222	1	< 0.1%
0.008942079464	1	< 0.1%
0.008952344884	1	< 0.1%
0.00926504882	1	< 0.1%

Value	Count	Frequency (%)
10.13682209	1	< 0.1%
9.585185913	1	< 0.1%
9.381676813	1	< 0.1%
9.339974856	1	< 0.1%
9.3307273	1	< 0.1%
9.255334017	1	< 0.1%
9.218856604	1	< 0.1%
9.098559152	1	< 0.1%
9.040570008	1	< 0.1%
8.905034018	1	< 0.1%

LNCAP_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14750
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.170622421

Minimum	0
Maximum	11.27863947
Zeros	369
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2118453749
Q1	1.553131411
median	2.921058785
Q3	4.594828442
95-th percentile	6.800958263
Maximum	11.27863947
Range	11.27863947
Interquartile range (IQR)	3.041697031

Descriptive statistics

Standard deviation	2.038556106
Coefficient of variation (CV)	0.6429513942
Kurtosis	-0.5720665357
Mean	3.170622421
Median Absolute Deviation (MAD)	1.506134227
Skewness	0.4348772092
Sum	51513.10248
Variance	4.155710999
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	369	2.3%
4.972031953	13	0.1%
2.56057983	10	0.1%
1.841841219	9	0.1%
2.24395748	9	0.1%
3.214331118	8	< 0.1%
1.849674707	8	< 0.1%
1.753941296	7	< 0.1%
1.61309388	7	< 0.1%
1.323394705	7	< 0.1%
Other values (14740)	15800	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	369	2.3%
0.0106072226	1	< 0.1%
0.01110788901	1	< 0.1%
0.01137411745	1	< 0.1%
0.01368404915	1	< 0.1%
0.01384666598	1	< 0.1%
0.01402416429	1	< 0.1%
0.01418518092	1	< 0.1%
0.01600897419	1	< 0.1%
0.01672058634	1	< 0.1%

Value	Count	Frequency (%)
11.27863947	1	< 0.1%
10.85918046	1	< 0.1%
10.14605602	1	< 0.1%
10.07795667	1	< 0.1%
10.00854891	1	< 0.1%
9.999968563	1	< 0.1%
9.86297065	1	< 0.1%
9.862245892	1	< 0.1%
9.862099669	1	< 0.1%
9.350961232	1	< 0.1%

MR49F_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14935
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.335691402

Minimum	0
Maximum	11.18376443
Zeros	347
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2673336802
Q1	1.742734009
median	3.415217881
Q3	4.790194171
95-th percentile	6.372388118
Maximum	11.18376443
Range	11.18376443
Interquartile range (IQR)	3.047460162

Descriptive statistics

Standard deviation	1.916229079
Coefficient of variation (CV)	0.5744623371
Kurtosis	-0.7302829836
Mean	3.335691402
Median Absolute Deviation (MAD)	1.496568527
Skewness	0.08503429769
Sum	54194.97821
Variance	3.671933882
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	347	2.1%
4.680661174	10	0.1%
5.083030534	8	< 0.1%
1.378215641	7	< 0.1%
1.421273561	7	< 0.1%
2.458231946	6	< 0.1%
3.715168513	6	< 0.1%
1.232038994	6	< 0.1%
2.371443963	6	< 0.1%
1.067424728	5	< 0.1%
Other values (14925)	15839	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	347	2.1%
0.01116848872	1	< 0.1%
0.01474021585	1	< 0.1%
0.01729589418	1	< 0.1%
0.01846786836	1	< 0.1%
0.01922212204	1	< 0.1%
0.0211557299	1	< 0.1%
0.02135020539	1	< 0.1%
0.02374009929	1	< 0.1%
0.02403337955	1	< 0.1%

Value	Count	Frequency (%)
11.18376443	1	< 0.1%
11.1236078	1	< 0.1%
10.49676789	1	< 0.1%
10.45757236	1	< 0.1%
10.26370694	1	< 0.1%
9.909333935	1	< 0.1%
9.87355291	1	< 0.1%
9.47536619	1	< 0.1%
9.404246334	1	< 0.1%
9.36201705	1	< 0.1%

MR49F_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	15162
Distinct (%)	93.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.205655746

Minimum	0
Maximum	10.60045403
Zeros	391
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.100310536
Q1	1.230356571
median	3.307936456
Q3	4.824569729
95-th percentile	6.670607537
Maximum	10.60045403
Range	10.60045403
Interquartile range (IQR)	3.594213158

Descriptive statistics

Standard deviation	2.128807721
Coefficient of variation (CV)	0.6640787063
Kurtosis	-0.9330491874
Mean	3.205655746
Median Absolute Deviation (MAD)	1.732826412
Skewness	0.1348126163
Sum	52082.2889
Variance	4.531822312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	391	2.4%
4.082015953	9	0.1%
3.684952162	9	0.1%
2.232543068	7	< 0.1%
3.863081883	7	< 0.1%
3.016593565	6	< 0.1%
3.405601413	6	< 0.1%
2.870571052	6	< 0.1%
2.635317402	6	< 0.1%
3.190720347	5	< 0.1%
Other values (15152)	15795	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	391	2.4%
0.006622432443	1	< 0.1%
0.00970419668	1	< 0.1%
0.009786511087	1	< 0.1%
0.0114478721	1	< 0.1%
0.01157638435	1	< 0.1%
0.01190517702	1	< 0.1%
0.01219931571	1	< 0.1%
0.01443426853	1	< 0.1%
0.01457144581	1	< 0.1%

Value	Count	Frequency (%)
10.60045403	1	< 0.1%
10.09090599	1	< 0.1%
10.07249919	1	< 0.1%
9.932987168	1	< 0.1%
9.814446203	1	< 0.1%
9.570677755	1	< 0.1%
9.355630347	1	< 0.1%
9.326471067	1	< 0.1%
9.221123404	1	< 0.1%
9.190004007	1	< 0.1%

MR49F_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	15462
Distinct (%)	95.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.015268981

Minimum	0
Maximum	9.446667343
Zeros	406
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	127.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.06225739323
Q1	0.7613259992
median	1.944723548
Q3	3.000945426
95-th percentile	4.516097249
Maximum	9.446667343
Range	9.446667343
Interquartile range (IQR)	2.239619426

Descriptive statistics

Standard deviation	1.434541045
Coefficient of variation (CV)	0.7118360172
Kurtosis	-0.1312599355
Mean	2.015268981
Median Absolute Deviation (MAD)	1.1225988
Skewness	0.5287846222
Sum	32742.07514
Variance	2.05790801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	406	2.5%
1.648388857	7	< 0.1%
2.981569793	7	< 0.1%
3.155403234	6	< 0.1%
1.872650085	6	< 0.1%
2.710650819	5	< 0.1%
2.809339777	5	< 0.1%
2.240411218	5	< 0.1%
1.868513324	5	< 0.1%
2.65417343	5	< 0.1%
Other values (15452)	15790	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	406	2.5%
0.006269502546	1	< 0.1%
0.00628212709	1	< 0.1%
0.006704384758	1	< 0.1%
0.006854134571	1	< 0.1%
0.007255755499	1	< 0.1%
0.007302935069	1	< 0.1%
0.008018836872	1	< 0.1%
0.008185396726	1	< 0.1%
0.008648685437	1	< 0.1%

Value	Count	Frequency (%)
9.446667343	1	< 0.1%
8.642418798	1	< 0.1%
8.493713441	1	< 0.1%
8.14758228	1	< 0.1%
8.037426517	1	< 0.1%
7.918311075	1	< 0.1%
7.896995771	1	< 0.1%
7.840850022	1	< 0.1%
7.836341432	1	< 0.1%
7.670230997	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	gene	C42_1	C42_2	C42_3	C42B_1	C42B_2	C42B_3	LNCAP_1	LNCAP_2	LNCAP_3	MR49F_1	MR49F_2	MR49F_3
0	ENSG00000000003	2.020308	3.112967	4.462864	5.802458	3.613909	5.196959	3.463763	6.038525	3.020616	3.090618	4.856630	2.818450
1	ENSG00000000419	4.223350	1.740524	3.583093	7.149923	2.633272	5.046861	5.323355	7.286943	2.032127	2.755359	5.089189	3.712340
2	ENSG00000000457	2.869919	2.559274	3.979699	1.596058	1.156747	2.912101	3.677716	4.129601	1.965240	4.178899	2.305354	1.173922
3	ENSG00000000460	1.751904	2.288179	4.507209	3.421740	2.349831	1.407528	3.052585	5.859453	2.044142	3.070865	3.197595	1.739958
4	ENSG00000001036	3.481197	3.873432	6.349452	5.683603	3.554372	3.415789	5.241517	4.548365	2.861295	4.872132	4.504407	3.250109
5	ENSG00000001084	2.942330	2.568641	3.532785	7.268647	3.932047	5.233605	5.019059	1.963537	2.212093	4.332983	5.059249	4.626412
6	ENSG00000001167	2.236061	1.206965	4.833317	3.346900	4.245998	5.438745	5.522757	4.487946	3.552754	2.320159	3.754814	3.025724
7	ENSG00000001460	1.185808	1.407207	2.029862	2.241934	0.417379	2.114580	2.665455	4.018895	1.031236	1.940269	1.614235	1.027777
8	ENSG00000001461	2.176179	2.603797	3.826845	6.807153	2.424623	4.923654	4.610918	3.572004	2.635768	3.893572	4.763568	2.041859
9	ENSG00000001497	3.180836	2.972655	4.455014	5.352977	2.603786	3.039676	6.119891	4.087531	2.419599	4.022550	5.323447	3.182143

Last rows

	gene	C42_1	C42_2	C42_3	C42B_1	C42B_2	C42B_3	LNCAP_1	LNCAP_2	LNCAP_3	MR49F_1	MR49F_2	MR49F_3
16237	ENSG00000283486	0.271255	1.925560	2.885454	0.305087	0.382366	0.869975	0.000000	0.175830	0.222268	0.131416	0.082574	1.648389
16238	ENSG00000283491	0.471255	1.609023	3.047016	0.432820	2.682926	0.847827	3.991851	0.684949	1.756452	1.500062	0.494098	2.121968
16239	ENSG00000283498	0.630158	1.369592	3.471739	0.319602	0.650447	2.151193	3.970516	0.350326	1.267728	1.371925	0.568415	3.412563
16240	ENSG00000283511	0.976471	0.633461	1.748475	0.890837	1.292388	1.735363	0.037296	0.011684	0.389971	1.157952	0.151181	2.265861
16241	ENSG00000283526	2.008367	1.513195	2.990982	1.396151	2.474243	3.446476	5.218036	0.538444	4.453536	1.438513	0.725542	4.200088
16242	ENSG00000283577	0.000000	0.000000	0.000000	0.668517	1.013959	0.683460	0.000000	0.000000	0.000000	0.089811	0.023367	1.100471
16243	ENSG00000283633	0.000000	0.000000	0.000000	0.378588	2.312889	2.672558	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
16244	ENSG00000283667	0.080286	0.891543	2.111469	0.202083	0.645639	0.690646	2.258987	0.162713	0.169281	1.889044	0.525394	3.102266
16245	ENSG00000283674	0.503064	3.560078	4.192234	1.205395	2.148792	2.678159	2.181762	0.831979	1.423840	1.286498	0.403138	3.155403
16246	ENSG00000283689	0.110153	0.227055	1.276767	0.291591	1.551455	0.810000	1.223937	0.183202	0.920441	1.135927	0.375598	2.738001

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows